Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 331234 |
| Missing cells | 53924 |
| Missing cells (%) | 1.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 35.4 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with BEHANDELEND_SPECIALISME_CD and 1 other fields | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 53924 (16.3%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.16585803) | Skewed |
Reproduction
| Analysis started | 2023-06-21 12:44:33.733351 |
|---|---|
| Analysis finished | 2023-06-21 12:44:54.389734 |
| Duration | 20.66 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 993702 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 331234 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 331234 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 331234 | |
| . | 331234 | |
| 0 | 331234 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 662468 | |
| Other Punctuation | 331234 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 331234 | |
| 0 | 331234 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 331234 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 993702 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 331234 | |
| . | 331234 | |
| 0 | 331234 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 993702 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 331234 | |
| . | 331234 | |
| 0 | 331234 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
| Minimum | 2023-06-07 00:00:00 |
|---|---|
| Maximum | 2023-06-07 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
| Minimum | 2023-06-01 00:00:00 |
|---|---|
| Maximum | 2023-06-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Histogram with fixed size bins (bins=12)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 445.2422 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1016.7909 |
|---|---|
| Coefficient of variation (CV) | 2.2836805 |
| Kurtosis | 57.389814 |
| Mean | 445.2422 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.7012982 |
| Sum | 1.4747935 × 108 |
| Variance | 1033863.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 46612 | |
| 313 | 42974 | |
| 303 | 38212 | |
| 330 | 26164 | 7.9% |
| 316 | 22451 | 6.8% |
| 308 | 17728 | 5.4% |
| 306 | 13887 | 4.2% |
| 324 | 13522 | 4.1% |
| 301 | 13285 | 4.0% |
| 304 | 10778 | 3.3% |
| Other values (18) | 85621 |
| Value | Count | Frequency (%) |
| 301 | 13285 | 4.0% |
| 302 | 7296 | 2.2% |
| 303 | 38212 | |
| 304 | 10778 | 3.3% |
| 305 | 46612 | |
| 306 | 13887 | 4.2% |
| 307 | 5839 | 1.8% |
| 308 | 17728 | 5.4% |
| 310 | 3663 | 1.1% |
| 313 | 42974 |
| Value | Count | Frequency (%) |
| 8418 | 4562 | 1.4% |
| 8416 | 730 | 0.2% |
| 1900 | 222 | 0.1% |
| 390 | 922 | 0.3% |
| 389 | 3502 | 1.1% |
| 362 | 4357 | 1.3% |
| 361 | 2410 | 0.7% |
| 335 | 3340 | 1.0% |
| 330 | 26164 | |
| 329 | 874 | 0.3% |
| Distinct | 1900 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.5 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3512894 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1110061 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 09 |
|---|---|
| 2nd row | 16 |
| 3rd row | 06 |
| 4th row | 08 |
| 5th row | 17 |
| Value | Count | Frequency (%) |
| 101 | 1424 | 0.4% |
| 402 | 1374 | 0.4% |
| 403 | 1333 | 0.4% |
| 301 | 1332 | 0.4% |
| 201 | 1261 | 0.4% |
| 203 | 1247 | 0.4% |
| 401 | 1119 | 0.3% |
| 404 | 1104 | 0.3% |
| 409 | 1083 | 0.3% |
| 302 | 1071 | 0.3% |
| Other values (1890) | 318886 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 212402 | |
| 0 | 203795 | |
| 2 | 147046 | |
| 3 | 120342 | |
| 5 | 85530 | |
| 9 | 79983 | 7.2% |
| 4 | 78714 | 7.1% |
| 7 | 65332 | 5.9% |
| 6 | 57889 | 5.2% |
| 8 | 47808 | 4.3% |
| Other values (15) | 11220 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1098841 | |
| Uppercase Letter | 11220 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2127 | |
| M | 1882 | |
| B | 1346 | |
| Z | 949 | |
| E | 938 | |
| D | 741 | 6.6% |
| A | 723 | 6.4% |
| F | 709 | 6.3% |
| C | 365 | 3.3% |
| K | 363 | 3.2% |
| Other values (5) | 1077 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 212402 | |
| 0 | 203795 | |
| 2 | 147046 | |
| 3 | 120342 | |
| 5 | 85530 | |
| 9 | 79983 | 7.3% |
| 4 | 78714 | 7.2% |
| 7 | 65332 | 5.9% |
| 6 | 57889 | 5.3% |
| 8 | 47808 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1098841 | |
| Latin | 11220 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2127 | |
| M | 1882 | |
| B | 1346 | |
| Z | 949 | |
| E | 938 | |
| D | 741 | 6.6% |
| A | 723 | 6.4% |
| F | 709 | 6.3% |
| C | 365 | 3.3% |
| K | 363 | 3.2% |
| Other values (5) | 1077 |
Common
| Value | Count | Frequency (%) |
| 1 | 212402 | |
| 0 | 203795 | |
| 2 | 147046 | |
| 3 | 120342 | |
| 5 | 85530 | |
| 9 | 79983 | 7.3% |
| 4 | 78714 | 7.2% |
| 7 | 65332 | 5.9% |
| 6 | 57889 | 5.3% |
| 8 | 47808 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1110061 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 212402 | |
| 0 | 203795 | |
| 2 | 147046 | |
| 3 | 120342 | |
| 5 | 85530 | |
| 9 | 79983 | 7.2% |
| 4 | 78714 | 7.1% |
| 7 | 65332 | 5.9% |
| 6 | 57889 | 5.2% |
| 8 | 47808 | 4.3% |
| Other values (15) | 11220 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6094 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4043384 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999038 |
| Q1 | 99799061 |
| median | 1.4959903 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020396 × 108 |
Descriptive statistics
| Standard deviation | 4.2886734 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97373839 |
| Kurtosis | -1.7354955 |
| Mean | 4.4043384 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.46948435 |
| Sum | 1.4588666 × 1014 |
| Variance | 1.8392719 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2423 | 0.7% |
| 990004007 | 2366 | 0.7% |
| 990003004 | 2295 | 0.7% |
| 990004006 | 1900 | 0.6% |
| 990356076 | 1722 | 0.5% |
| 131999228 | 1609 | 0.5% |
| 990356073 | 1603 | 0.5% |
| 131999164 | 1572 | 0.5% |
| 990003007 | 1481 | 0.4% |
| 131999194 | 1403 | 0.4% |
| Other values (6084) | 312860 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 11 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 3 | < 0.1% |
| 11101002 | 10 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 165 | |
| 998418080 | 148 | |
| 998418079 | 38 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 228 | |
| 998418073 | 222 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10286 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 518.98908 |
| Minimum | 1 |
|---|---|
| Maximum | 165128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 101 |
| 95-th percentile | 1756 |
| Maximum | 165128 |
| Range | 165127 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 3218.4739 |
|---|---|
| Coefficient of variation (CV) | 6.2014289 |
| Kurtosis | 401.77703 |
| Mean | 518.98908 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.617483 |
| Sum | 1.7190683 × 108 |
| Variance | 10358574 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55658 | 16.8% |
| 2 | 27102 | 8.2% |
| 3 | 17591 | 5.3% |
| 4 | 12817 | 3.9% |
| 5 | 10013 | 3.0% |
| 6 | 8510 | 2.6% |
| 7 | 7066 | 2.1% |
| 8 | 5948 | 1.8% |
| 9 | 5423 | 1.6% |
| 10 | 4817 | 1.5% |
| Other values (10276) | 176289 |
| Value | Count | Frequency (%) |
| 1 | 55658 | |
| 2 | 27102 | |
| 3 | 17591 | 5.3% |
| 4 | 12817 | 3.9% |
| 5 | 10013 | 3.0% |
| 6 | 8510 | 2.6% |
| 7 | 7066 | 2.1% |
| 8 | 5948 | 1.8% |
| 9 | 5423 | 1.6% |
| 10 | 4817 | 1.5% |
| Value | Count | Frequency (%) |
| 165128 | 1 | |
| 162289 | 1 | |
| 155871 | 1 | |
| 154259 | 1 | |
| 154257 | 1 | |
| 145500 | 1 | |
| 144716 | 1 | |
| 118397 | 1 | |
| 115938 | 1 | |
| 113248 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11051 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 614.9957 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 111 |
| 95-th percentile | 2002 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 108 |
Descriptive statistics
| Standard deviation | 4148.3667 |
|---|---|
| Coefficient of variation (CV) | 6.7453589 |
| Kurtosis | 710.04832 |
| Mean | 614.9957 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.165858 |
| Sum | 2.0370748 × 108 |
| Variance | 17208946 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 53606 | 16.2% |
| 2 | 26630 | 8.0% |
| 3 | 17426 | 5.3% |
| 4 | 12623 | 3.8% |
| 5 | 9925 | 3.0% |
| 6 | 8483 | 2.6% |
| 7 | 6998 | 2.1% |
| 8 | 5891 | 1.8% |
| 9 | 5343 | 1.6% |
| 10 | 4840 | 1.5% |
| Other values (11041) | 179469 |
| Value | Count | Frequency (%) |
| 1 | 53606 | |
| 2 | 26630 | |
| 3 | 17426 | 5.3% |
| 4 | 12623 | 3.8% |
| 5 | 9925 | 3.0% |
| 6 | 8483 | 2.6% |
| 7 | 6998 | 2.1% |
| 8 | 5891 | 1.8% |
| 9 | 5343 | 1.6% |
| 10 | 4840 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230966 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226320 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215053 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9153 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7786.4381 |
| Minimum | 1 |
|---|---|
| Maximum | 230257 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 380 |
| median | 1706 |
| Q3 | 6398 |
| 95-th percentile | 37219.05 |
| Maximum | 230257 |
| Range | 230256 |
| Interquartile range (IQR) | 6018 |
Descriptive statistics
| Standard deviation | 18115.485 |
|---|---|
| Coefficient of variation (CV) | 2.3265433 |
| Kurtosis | 33.791106 |
| Mean | 7786.4381 |
| Median Absolute Deviation (MAD) | 1571 |
| Skewness | 5.0385032 |
| Sum | 2.579133 × 109 |
| Variance | 3.281708 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9 | 655 | 0.2% |
| 3 | 642 | 0.2% |
| 1 | 621 | 0.2% |
| 2 | 620 | 0.2% |
| 4 | 596 | 0.2% |
| 17 | 594 | 0.2% |
| 21 | 593 | 0.2% |
| 12 | 575 | 0.2% |
| 8 | 567 | 0.2% |
| 19 | 566 | 0.2% |
| Other values (9143) | 325205 |
| Value | Count | Frequency (%) |
| 1 | 621 | |
| 2 | 620 | |
| 3 | 642 | |
| 4 | 596 | |
| 5 | 520 | |
| 6 | 546 | |
| 7 | 545 | |
| 8 | 567 | |
| 9 | 655 | |
| 10 | 492 |
| Value | Count | Frequency (%) |
| 230257 | 23 | |
| 227944 | 23 | |
| 217928 | 24 | |
| 217721 | 19 | |
| 214510 | 17 | |
| 213517 | 25 | |
| 211593 | 17 | |
| 210418 | 19 | |
| 205347 | 17 | |
| 200603 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10245 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11288.89 |
| Minimum | 1 |
|---|---|
| Maximum | 369972 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 42 |
| Q1 | 507 |
| median | 2382 |
| Q3 | 9250 |
| 95-th percentile | 53325 |
| Maximum | 369972 |
| Range | 369971 |
| Interquartile range (IQR) | 8743 |
Descriptive statistics
| Standard deviation | 27113.987 |
|---|---|
| Coefficient of variation (CV) | 2.4018293 |
| Kurtosis | 37.016813 |
| Mean | 11288.89 |
| Median Absolute Deviation (MAD) | 2209 |
| Skewness | 5.2661527 |
| Sum | 3.7392642 × 109 |
| Variance | 7.351683 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3 | 558 | 0.2% |
| 1 | 533 | 0.2% |
| 4 | 526 | 0.2% |
| 2 | 512 | 0.2% |
| 7 | 471 | 0.1% |
| 17 | 470 | 0.1% |
| 6 | 461 | 0.1% |
| 12 | 455 | 0.1% |
| 25 | 454 | 0.1% |
| 20 | 454 | 0.1% |
| Other values (10235) | 326340 |
| Value | Count | Frequency (%) |
| 1 | 533 | |
| 2 | 512 | |
| 3 | 558 | |
| 4 | 526 | |
| 5 | 440 | |
| 6 | 461 | |
| 7 | 471 | |
| 8 | 420 | |
| 9 | 449 | |
| 10 | 446 |
| Value | Count | Frequency (%) |
| 369972 | 23 | |
| 364722 | 23 | |
| 348487 | 25 | |
| 343256 | 24 | |
| 341654 | 19 | |
| 323757 | 20 | |
| 319214 | 19 | |
| 315780 | 17 | |
| 310778 | 17 | |
| 298646 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 677874.62 |
| Minimum | 190 |
|---|---|
| Maximum | 1487638 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 190 |
|---|---|
| 5-th percentile | 32192 |
| Q1 | 284963 |
| median | 761460 |
| Q3 | 1026359 |
| 95-th percentile | 1340635 |
| Maximum | 1487638 |
| Range | 1487448 |
| Interquartile range (IQR) | 741396 |
Descriptive statistics
| Standard deviation | 420049.63 |
|---|---|
| Coefficient of variation (CV) | 0.61965682 |
| Kurtosis | -1.134238 |
| Mean | 677874.62 |
| Median Absolute Deviation (MAD) | 315834 |
| Skewness | -0.076779739 |
| Sum | 2.2453512 × 1011 |
| Variance | 1.7644169 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880933 | 5102 | 1.5% |
| 874099 | 4354 | 1.3% |
| 843976 | 4347 | 1.3% |
| 894317 | 4333 | 1.3% |
| 880476 | 4273 | 1.3% |
| 897707 | 4212 | 1.3% |
| 765023 | 4089 | 1.2% |
| 803443 | 4029 | 1.2% |
| 737384 | 3899 | 1.2% |
| 1080888 | 3890 | 1.2% |
| Other values (315) | 288706 |
| Value | Count | Frequency (%) |
| 190 | 65 | < 0.1% |
| 310 | 39 | < 0.1% |
| 325 | 54 | < 0.1% |
| 332 | 125 | |
| 349 | 72 | < 0.1% |
| 710 | 185 | |
| 895 | 19 | < 0.1% |
| 974 | 201 | |
| 1583 | 87 | |
| 1610 | 130 |
| Value | Count | Frequency (%) |
| 1487638 | 2975 | |
| 1450398 | 3048 | |
| 1421726 | 3564 | |
| 1344332 | 3543 | |
| 1340635 | 3441 | |
| 1332357 | 3545 | |
| 1316425 | 3463 | |
| 1282945 | 3576 | |
| 1267076 | 3351 | |
| 1265243 | 1177 | 0.4% |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1100571.9 |
| Minimum | 190 |
|---|---|
| Maximum | 2664767 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 190 |
|---|---|
| 5-th percentile | 39189 |
| Q1 | 483086 |
| median | 1106953 |
| Q3 | 1804756 |
| 95-th percentile | 2548625 |
| Maximum | 2664767 |
| Range | 2664577 |
| Interquartile range (IQR) | 1321670 |
Descriptive statistics
| Standard deviation | 750926.87 |
|---|---|
| Coefficient of variation (CV) | 0.68230604 |
| Kurtosis | -0.84182243 |
| Mean | 1100571.9 |
| Median Absolute Deviation (MAD) | 649709 |
| Skewness | 0.29526518 |
| Sum | 3.6454684 × 1011 |
| Variance | 5.6389116 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211794 | 5102 | 1.5% |
| 1281495 | 4354 | 1.3% |
| 1216252 | 4347 | 1.3% |
| 1315578 | 4333 | 1.3% |
| 1300438 | 4273 | 1.3% |
| 1341839 | 4212 | 1.3% |
| 1155938 | 4089 | 1.2% |
| 1205199 | 4029 | 1.2% |
| 1048692 | 3899 | 1.2% |
| 2548625 | 3890 | 1.2% |
| Other values (315) | 288706 |
| Value | Count | Frequency (%) |
| 190 | 65 | < 0.1% |
| 312 | 39 | < 0.1% |
| 325 | 54 | < 0.1% |
| 333 | 125 | |
| 442 | 72 | < 0.1% |
| 761 | 185 | |
| 913 | 19 | < 0.1% |
| 989 | 201 | |
| 1634 | 87 | |
| 1798 | 82 |
| Value | Count | Frequency (%) |
| 2664767 | 3866 | |
| 2662690 | 3793 | |
| 2619190 | 3789 | |
| 2594043 | 3844 | |
| 2548625 | 3890 | |
| 2480327 | 3851 | |
| 2282118 | 3797 | |
| 2178764 | 3757 | |
| 2062352 | 3811 | |
| 2052303 | 1168 | 0.4% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3564 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 53924 |
| Missing (%) | 16.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3596.4582 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 480 |
| median | 1255 |
| Q3 | 4190 |
| 95-th percentile | 13700 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3710 |
Descriptive statistics
| Standard deviation | 6553.8228 |
|---|---|
| Coefficient of variation (CV) | 1.8222992 |
| Kurtosis | 142.45115 |
| Mean | 3596.4582 |
| Median Absolute Deviation (MAD) | 1025 |
| Skewness | 7.1226277 |
| Sum | 9.9733381 × 108 |
| Variance | 42952594 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2086 | 0.6% |
| 105 | 1951 | 0.6% |
| 110 | 1791 | 0.5% |
| 185 | 1672 | 0.5% |
| 180 | 1602 | 0.5% |
| 300 | 1415 | 0.4% |
| 175 | 1393 | 0.4% |
| 145 | 1379 | 0.4% |
| 120 | 1357 | 0.4% |
| 140 | 1325 | 0.4% |
| Other values (3554) | 261339 | |
| (Missing) | 53924 | 16.3% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 668 | 0.2% |
| 95 | 719 | 0.2% |
| 100 | 966 | |
| 105 | 1951 | |
| 110 | 1791 | |
| 115 | 1099 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99515 | 5 |
| BEHANDELEND_SPECIALISME_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|
| BEHANDELEND_SPECIALISME_CD | 1.000 | 0.216 | 0.008 | 0.013 | -0.059 | -0.053 | -0.542 | -0.460 | 0.052 |
| ZORGPRODUCT_CD | 0.216 | 1.000 | -0.136 | -0.144 | -0.168 | -0.200 | -0.364 | -0.394 | 0.028 |
| AANTAL_PAT_PER_ZPD | 0.008 | -0.136 | 1.000 | 0.996 | 0.336 | 0.334 | 0.094 | 0.102 | -0.299 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.013 | -0.144 | 0.996 | 1.000 | 0.332 | 0.334 | 0.097 | 0.109 | -0.301 |
| AANTAL_PAT_PER_DIAG | -0.059 | -0.168 | 0.336 | 0.332 | 1.000 | 0.988 | 0.350 | 0.331 | 0.030 |
| AANTAL_SUBTRAJECT_PER_DIAG | -0.053 | -0.200 | 0.334 | 0.334 | 0.988 | 1.000 | 0.363 | 0.360 | 0.039 |
| AANTAL_PAT_PER_SPC | -0.542 | -0.364 | 0.094 | 0.097 | 0.350 | 0.363 | 1.000 | 0.960 | -0.007 |
| AANTAL_SUBTRAJECT_PER_SPC | -0.460 | -0.394 | 0.102 | 0.109 | 0.331 | 0.360 | 0.960 | 1.000 | -0.009 |
| GEMIDDELDE_VERKOOPPRIJS | 0.052 | 0.028 | -0.299 | -0.301 | 0.030 | 0.039 | -0.007 | -0.009 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 09 | 990029010 | 1 | 1 | 24 | 25 | 21981 | 24168 | 1345.0 |
| 1 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 16 | 990029011 | 546 | 577 | 1077 | 1196 | 21981 | 24168 | 545.0 |
| 2 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 06 | 990029010 | 458 | 467 | 3332 | 3526 | 21981 | 24168 | 1345.0 |
| 3 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 08 | 990029012 | 47 | 48 | 162 | 167 | 21981 | 24168 | 1040.0 |
| 4 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 17 | 990029012 | 148 | 148 | 695 | 704 | 21981 | 24168 | 1040.0 |
| 5 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 13 | 990029010 | 30 | 31 | 156 | 157 | 21981 | 24168 | 1345.0 |
| 6 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 99 | 990029011 | 141 | 141 | 3708 | 3848 | 21981 | 24168 | 545.0 |
| 7 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 09 | 990029011 | 16 | 16 | 24 | 25 | 21981 | 24168 | 545.0 |
| 8 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 02 | 990029012 | 1726 | 1736 | 4872 | 4977 | 21981 | 24168 | 1040.0 |
| 9 | 1.0 | 2023-06-07 | 2023-06-01 | 2018-01-01 | 329 | 15 | 990029002 | 149 | 150 | 1029 | 1075 | 21981 | 24168 | 205.0 |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331224 | 1.0 | 2023-06-07 | 2023-06-01 | 2016-01-01 | 303 | 143 | 131999094 | 1 | 1 | 147 | 205 | 1332357 | 1831603 | 590.0 |
| 331225 | 1.0 | 2023-06-07 | 2023-06-01 | 2015-01-01 | 322 | 1903 | 60607008 | 1 | 1 | 15746 | 19525 | 442154 | 759804 | 430.0 |
| 331226 | 1.0 | 2023-06-07 | 2023-06-01 | 2012-01-01 | 303 | 212 | 199299087 | 2 | 2 | 37471 | 42301 | 1487638 | 1939510 | 2190.0 |
| 331227 | 1.0 | 2023-06-07 | 2023-06-01 | 2014-01-01 | 313 | 944 | 19999006 | 1 | 1 | 2982 | 3456 | 1037354 | 2062352 | 23300.0 |
| 331228 | 1.0 | 2023-06-07 | 2023-06-01 | 2016-01-01 | 303 | 801 | 990356060 | 1 | 1 | 153 | 205 | 1332357 | 1831603 | 4325.0 |
| 331229 | 1.0 | 2023-06-07 | 2023-06-01 | 2012-01-01 | 303 | 602 | 199299059 | 1 | 1 | 3099 | 3563 | 1487638 | 1939510 | 1760.0 |
| 331230 | 1.0 | 2023-06-07 | 2023-06-01 | 2014-01-01 | 313 | 916 | 990003004 | 1 | 1 | 2106 | 2399 | 1037354 | 2062352 | 105.0 |
| 331231 | 1.0 | 2023-06-07 | 2023-06-01 | 2015-01-01 | 301 | 603 | 79799039 | 1 | 1 | 270 | 423 | 1084428 | 1653309 | 355.0 |
| 331232 | 1.0 | 2023-06-07 | 2023-06-01 | 2014-01-01 | 313 | 773 | 28999035 | 1 | 1 | 247 | 1473 | 1037354 | 2062352 | 710.0 |
| 331233 | 1.0 | 2023-06-07 | 2023-06-01 | 2022-01-01 | 306 | 075 | 990356060 | 1 | 1 | 2219 | 2873 | 495813 | 764538 | 4755.0 |